Vacuum Database
Overview
When an lottery is deleted from the database, it leaves behind empty space.
This makes the database file larger than it needs to be, but can speed up
inserts. In time, inserts and deletes can leave the database file structure
fragmented, which slows down disk access to the database contents. Vacuuming
the database cleans the main database by copying its contents to a temporary
database file and reloading the original database file from the copy. This
eliminates free pages, aligns table data to be contiguous, and otherwise
cleans up the database file structure.
How to Invoke
Use the menu item "Utilities > Database Utilities > Vacuum Database" .